2014-09-04 - 14114.100 - Spec - Develop new report based on sent Spec #CrystalReportDevelopment
SPECIFICATIONS
14114.100 - Develop new report based on sent Spec
Purpose
Report that will allow users to track performance for custom seasons.
Admin Info
Purpose
|
Develop new report based on sent Spec.
|
Requested By
|
Mark Grzechowiak
|
Spec Created By
|
Praveen Guntuka
|
Spec Created Date
|
09/05/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SA930 - Custom Seasons by Material
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Other activity
|
04
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
CustomSeasons_FunctionalSpec.docx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Remove Account parameter form the report and add Customer(Multiple and mandatory) parameter in the report.
|
Mark Grzechowiak
|
09/11/2014
|
None
|
2
|
Remove Account grouping from the report.
|
Mark Grzechowiak
|
09/11/2014
|
None
|
3
|
Details section need to show as in following order:
Customer, Collection, Season, Account, Material ID, Quantity and then Revenue.
|
Mark Grzechowiak
|
09/11/2014
|
None
|
4
|
Create Group on Customer and Details section need to show as in following order:
Collection, Material ID, Quantity and then Revenue.
Need to show Sum of Quantity and Revenue in respective Group Footer.
|
Mark Grzechowiak
|
09/11/2014
|
None
|
5
|
Rename report name to SA930 - Custom Season by Material.
|
Mark Grzechowiak
|
09/12/2014
|
None
|
6
|
Change Customer and Material parameters as Optional.
|
Mark Grzechowiak
|
09/12/2014
|
None
|
7
|
Suppress Details section and show when the Group drill down.
|
Mark Grzechowiak
|
09/12/2014
|
None
|
8
|
Show the details section in same page when drill down.
|
Mark Grzechowiak
|
09/12/2014
|
None
|
Functional Requirement
Purpose/WHY:
Report that will allow users to track performance for custom seasons.
In Scope:
In order to better understand how custom seasons are performing, users need to be able to view data at the Material level; this is not available ad-hoc in Analysis.
Out of Scope:
None
Solution Summary
1. Need to create report that includes required Dimensions and Measures.
2. Need to sort the report based on the required fields.
3. Need to create group based on Accounts field.
4. Need to create required Parameters in the report.
5. Need to restrict the report to show only 'Custom' seasons.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to create a report that should show Account, Season, Collection, Customer and Material ID dimensions.
2. Need to show Quantity and Revenue measures in the report.
3. Need to create a grouping on 'Account' field.
4. Need to sort the report based on Revenue, Quantity and Material ID.
5. Need to restrict the report to show only 'Custom' seasons.
6. Need to create 'Account' and 'Material ID' parameters in the report to restrict 'Account' and 'Material IDs'.
Issues
None